--------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  D:\users\llochner\Dropbox\JOINT PROJECTS\JPE_Child_Devp_2020\FINAL_Replication_CLMP_JPE/code/data_cleaning/prices/logs\wa
> getrim_cps.log
  log type:  text
 opened on:   4 Jul 2025, 13:32:08

. 
. * YEAR SPECIFIC HOURLY WAGES PRE-TRIMMING *
. forvalues y = 1992(1)2019 {
  2. 
. di as text "PRE-TRIMMED HOURLY WAGE IN YEAR: `y'"
  3. summarize hwage if year == `y', detail
  4. 
. }
PRE-TRIMMED HOURLY WAGE IN YEAR: 1992

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            1            .05
 5%          1.6       .2941176
10%     2.222222             .5       Obs               1,705
25%         4.25       .5714286       Sum of Wgt.       1,705

50%            6                      Mean           7.297437
                        Largest       Std. Dev.      5.404753
75%         8.75       45.83333
90%       13.125           47.5       Variance       29.21136
95%     17.30556         48.075       Skewness       2.651461
99%        26.25         48.075       Kurtosis        14.5522
PRE-TRIMMED HOURLY WAGE IN YEAR: 1993

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            1       .5151515
 5%          1.8       .6060606
10%          2.5             .7       Obs               1,634
25%          4.5       .7333333       Sum of Wgt.       1,634

50%            6                      Mean           7.609868
                        Largest       Std. Dev.      5.630433
75%         9.14             40
90%       14.425             40       Variance       31.70178
95%     18.21053          41.25       Skewness       2.910193
99%       28.125             75       Kurtosis       20.60843
PRE-TRIMMED HOURLY WAGE IN YEAR: 1994

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            1         .00575
 5%            2        .462963
10%     3.076667           .625       Obs               1,457
25%        4.923            .75       Sum of Wgt.       1,457

50%          6.5                      Mean           8.307041
                        Largest       Std. Dev.      6.827953
75%          9.6             55
90%     15.74067             60       Variance       46.62094
95%       20.868             60       Skewness       3.911029
99%     32.14286             96       Kurtosis       31.93184
PRE-TRIMMED HOURLY WAGE IN YEAR: 1995

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            1       .3333333
 5%            2       .4166667
10%        3.375             .5       Obs               1,475
25%            5           .625       Sum of Wgt.       1,475

50%      6.77875                      Mean           8.668902
                        Largest       Std. Dev.      7.525384
75%           10             60
90%     15.91429             60       Variance       56.63141
95%        21.25         61.111       Skewness       6.551626
99%           34            150       Kurtosis       95.25922
PRE-TRIMMED HOURLY WAGE IN YEAR: 1996

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%     1.111111             .1
 5%     2.272727            .45
10%     3.525556            .48       Obs               1,223
25%            5             .5       Sum of Wgt.       1,223

50%         6.75                      Mean            8.29353
                        Largest       Std. Dev.      5.632386
75%           10          38.44
90%     15.15152       39.28571       Variance       31.72377
95%     19.23075       39.43438       Skewness       2.333971
99%     30.95225             50       Kurtosis       11.05782
PRE-TRIMMED HOURLY WAGE IN YEAR: 1997

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            1       .0113636
 5%         2.45             .4
10%            4             .5       Obs               1,288
25%          5.5             .5       Sum of Wgt.       1,288

50%        7.305                      Mean           9.329465
                        Largest       Std. Dev.      7.284616
75%         10.5         48.075
90%      17.3075       54.42171       Variance       53.06563
95%         22.9             77       Skewness        3.57188
99%           36       91.66667       Kurtosis       26.25764
PRE-TRIMMED HOURLY WAGE IN YEAR: 1998

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         1.25       .4661616
 5%          2.5             .9
10%         4.55       .9226667       Obs               1,306
25%          5.8       .9323232       Sum of Wgt.       1,306

50%          7.5                      Mean           9.550036
                        Largest       Std. Dev.       7.43614
75%           11       72.11525
90%     17.28378             75       Variance       55.29618
95%           22       96.15367       Skewness       4.830338
99%       30.625            100       Kurtosis       45.16829
PRE-TRIMMED HOURLY WAGE IN YEAR: 1999

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%     1.111111       .0222222
 5%         2.76            .05
10%            5         .28825       Obs               1,314
25%            6             .5       Sum of Wgt.       1,314

50%            8                      Mean           10.43376
                        Largest       Std. Dev.      7.858115
75%        12.04             65
90%     19.23075             75       Variance       61.74998
95%           25       75.91079       Skewness       3.320285
99%           40             85       Kurtosis       21.79915
PRE-TRIMMED HOURLY WAGE IN YEAR: 2000

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%     1.285714       .0222222
 5%     3.296667       .0222222
10%            5       .5050505       Obs               1,357
25%          6.5         .57675       Sum of Wgt.       1,357

50%          8.5                      Mean            10.7381
                        Largest       Std. Dev.        7.2779
75%     12.23764          50.95
90%       20.175         55.275       Variance       52.96783
95%         25.6             64       Skewness       2.415805
99%           35             77       Kurtosis       13.20001
PRE-TRIMMED HOURLY WAGE IN YEAR: 2001

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%        1.546       .7142857
 5%          3.5         .99225
10%            5              1       Obs               1,496
25%         6.75              1       Sum of Wgt.       1,496

50%            9                      Mean           11.34011
                        Largest       Std. Dev.       8.50249
75%           13       72.11525
90%         20.8         76.923       Variance       72.29233
95%     27.14286             99       Skewness       3.624426
99%       43.269             99       Kurtosis       26.41747
PRE-TRIMMED HOURLY WAGE IN YEAR: 2002

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%     1.923056       .0333333
 5%     4.285714       .8333333
10%          5.7         1.1538       Obs               1,449
25%            7       1.166667       Sum of Wgt.       1,449

50%         9.17                      Mean           11.42374
                        Largest       Std. Dev.      7.713736
75%       13.221       65.91667
90%     19.73684         66.325       Variance       59.50172
95%           26       82.41743       Skewness       3.548056
99%      40.1315         100.75       Kurtosis       26.98311
PRE-TRIMMED HOURLY WAGE IN YEAR: 2003

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            2           .067
 5%       4.8075             .8
10%     5.714286           .875       Obs               1,973
25%            7           .894       Sum of Wgt.       1,973

50%            9                      Mean           11.04172
                        Largest       Std. Dev.      7.881811
75%        12.36             60
90%     19.23075             85       Variance       62.12294
95%           25            125       Skewness       5.217498
99%        37.68         131.25       Kurtosis       59.51563
PRE-TRIMMED HOURLY WAGE IN YEAR: 2004

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%       2.3075            .25
 5%            5             .8
10%            6        .972973       Obs               2,001
25%            7       1.048889       Sum of Wgt.       2,001

50%         9.05                      Mean            11.3526
                        Largest       Std. Dev.      8.459774
75%           13           72.1
90%     19.23075       83.33333       Variance       71.56777
95%           25             99       Skewness       7.866452
99%        38.45            200       Kurtosis       139.0346
PRE-TRIMMED HOURLY WAGE IN YEAR: 2005

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%        2.019           .019
 5%            5           .023
10%            6           .207       Obs               2,009
25%     7.366667       .5174747       Sum of Wgt.       2,009

50%         9.75                      Mean           11.65718
                        Largest       Std. Dev.       7.47521
75%         13.6       66.66667
90%           20             75       Variance       55.87877
95%           25             99       Skewness       3.533879
99%     38.57143          99.99       Kurtosis       28.71393
PRE-TRIMMED HOURLY WAGE IN YEAR: 2006

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         2.13            .05
 5%         5.15       .2857143
10%         6.02       .3428571       Obs               1,999
25%      7.69225       1.107172       Sum of Wgt.       1,999

50%           10                      Mean           12.17965
                        Largest       Std. Dev.      8.640773
75%           14       72.11525
90%     20.51267       72.11525       Variance       74.66296
95%         26.9       72.11525       Skewness       6.139939
99%         40.9       186.8129       Kurtosis       93.76882
PRE-TRIMMED HOURLY WAGE IN YEAR: 2007

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         2.37         .00075
 5%      5.46875             .2
10%          6.5             .5       Obs               1,986
25%            8             .5       Sum of Wgt.       1,986

50%           10                      Mean           12.45579
                        Largest       Std. Dev.      7.927533
75%       14.423          67.01
90%      21.6345       72.11525       Variance       62.84578
95%     27.77778       72.11525       Skewness       2.816961
99%         42.6           80.8       Kurtosis       15.73292
PRE-TRIMMED HOURLY WAGE IN YEAR: 2008

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%          2.5       .9608333
 5%     5.768333              1
10%            7           1.25       Obs               1,948
25%            8       1.333333       Sum of Wgt.       1,948

50%      10.3615                      Mean           12.96213
                        Largest       Std. Dev.      8.356801
75%           15          72.12
90%         22.5       76.86667       Variance       69.83612
95%        29.99           86.5       Skewness         2.9762
99%       44.225             90       Kurtosis       17.64224
PRE-TRIMMED HOURLY WAGE IN YEAR: 2009

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%     2.083333       .0003125
 5%         6.25       .0571429
10%         7.15              1       Obs               1,958
25%        8.125              1       Sum of Wgt.       1,958

50%         10.5                      Mean           13.73343
                        Largest       Std. Dev.      13.04819
75%        15.24          82.42
90%           24         84.615       Variance       170.2553
95%           31         213.46       Skewness       13.93377
99%     50.48075       378.2033       Kurtosis       342.9697
PRE-TRIMMED HOURLY WAGE IN YEAR: 2010

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            3            .75
 5%          6.5       1.458333
10%         7.25        1.52825       Obs               1,923
25%          8.5        1.73075       Sum of Wgt.       1,923

50%           11                      Mean           13.69463
                        Largest       Std. Dev.      8.887179
75%         15.8       72.11525
90%     24.03825       72.11525       Variance       78.98196
95%     30.68175          72.12       Skewness       2.990229
99%         47.3             99       Kurtosis       17.06767
PRE-TRIMMED HOURLY WAGE IN YEAR: 2011

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         2.65          .0625
 5%       6.7305          .9615
10%         7.34           1.15       Obs               1,934
25%          8.5           1.19       Sum of Wgt.       1,934

50%        10.75                      Mean           13.85145
                        Largest       Std. Dev.      9.633851
75%      15.3845       72.11525
90%     23.17857       72.11525       Variance       92.81109
95%           30          74.27       Skewness       3.304944
99%        57.65       115.3844       Kurtosis       19.39346
PRE-TRIMMED HOURLY WAGE IN YEAR: 2012

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         2.65       .0960526
 5%          6.5           .575
10%         7.31            .95       Obs               1,908
25%          8.5           1.07       Sum of Wgt.       1,908

50%     10.70214                      Mean           14.05207
                        Largest       Std. Dev.      16.08089
75%        15.43       82.41743
90%       23.611             85       Variance       258.5949
95%     30.28825        216.345       Skewness       21.79704
99%     51.42857          557.5       Kurtosis       699.0205
PRE-TRIMMED HOURLY WAGE IN YEAR: 2013

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%          3.2           1.07
 5%         7.25           1.25
10%          7.5       1.546392       Obs               1,819
25%         8.95          1.875       Sum of Wgt.       1,819

50%           11                      Mean           14.28498
                        Largest       Std. Dev.       10.2643
75%     15.86525       79.12086
90%     24.74733       90.14406       Variance       105.3559
95%        33.65            150       Skewness       4.678464
99%     53.64368          157.5       Kurtosis       46.16095
PRE-TRIMMED HOURLY WAGE IN YEAR: 2014

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%          3.6         .00575
 5%         7.25          1.275
10%            8       1.666667       Obs               1,787
25%            9           1.73       Sum of Wgt.       1,787

50%       11.525                      Mean            14.5344
                        Largest       Std. Dev.      9.179835
75%        16.75       72.11525
90%           25       72.11525       Variance       84.26937
95%           32       85.44444       Skewness       2.729432
99%           50             90       Kurtosis       14.14957
PRE-TRIMMED HOURLY WAGE IN YEAR: 2015

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            3             .1
 5%         7.25          .1625
10%            8             .4       Obs               1,832
25%            9          .4375       Sum of Wgt.       1,832

50%         11.5                      Mean           14.38404
                        Largest       Std. Dev.      9.354304
75%        16.12       72.11525
90%      24.2306       72.11525       Variance       87.50301
95%        31.25             80       Skewness        2.95286
99%      57.6922       82.41743       Kurtosis       15.09232
PRE-TRIMMED HOURLY WAGE IN YEAR: 2016

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%          3.5           .246
 5%          7.5            .95
10%            8        1.20175       Obs               1,798
25%         9.66       1.333333       Sum of Wgt.       1,798

50%       12.019                      Mean           15.19641
                        Largest       Std. Dev.      9.932933
75%         17.3       72.11525
90%       25.475          72.12       Variance       98.66316
95%        33.65             78       Skewness       3.656646
99%      57.6922       151.0986       Kurtosis       29.50825
PRE-TRIMMED HOURLY WAGE IN YEAR: 2017

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            3          .0012
 5%          7.5           .025
10%         8.25         .03425       Obs               1,775
25%           10             .6       Sum of Wgt.       1,775

50%         12.4                      Mean           16.25814
                        Largest       Std. Dev.      19.25361
75%      17.3075             74
90%     27.77774       192.3073       Variance       370.7013
95%     36.90475            250       Skewness       20.49574
99%     64.10244         634.61       Kurtosis       617.1567
PRE-TRIMMED HOURLY WAGE IN YEAR: 2018

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            4          .0875
 5%          7.5              1
10%          8.5           2.15       Obs               1,679
25%           10           2.18       Sum of Wgt.       1,679

50%           13                      Mean           15.83281
                        Largest       Std. Dev.      10.24594
75%        18.25       72.11525
90%        26.25       72.11525       Variance       104.9794
95%     33.03125        76.9228       Skewness       4.911656
99%       57.675       192.3073       Kurtosis       60.60117
PRE-TRIMMED HOURLY WAGE IN YEAR: 2019

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%          3.8       .2857143
 5%         7.25           1.07
10%      8.36087           1.25       Obs               1,607
25%           10       1.648286       Sum of Wgt.       1,607

50%           13                      Mean           15.97532
                        Largest       Std. Dev.      10.42288
75%           18       72.11525
90%         25.7          82.42       Variance       108.6364
95%           35             90       Skewness       2.987729
99%           65         90.125       Kurtosis        14.9687

. 
. * TRIMMING STEP *
. foreach hw of varlist hwage {
  2. forvalues y = 1992(1)2019 {
  3. 
. quietly summarize hwage if year == `y', detail
  4. scalar rp1_`hw'_`y'  = r(p1)
  5. scalar rp99_`hw'_`y' = r(p99) 
  6. 
. replace `hw' = . if (`hw' < rp1_`hw'_`y' | `hw' > rp99_`hw'_`y') & year == `y'
  7. 
. }
  8. }
(31 real changes made, 31 to missing)
(25 real changes made, 25 to missing)
(21 real changes made, 21 to missing)
(24 real changes made, 24 to missing)
(23 real changes made, 23 to missing)
(17 real changes made, 17 to missing)
(25 real changes made, 25 to missing)
(26 real changes made, 26 to missing)
(26 real changes made, 26 to missing)
(28 real changes made, 28 to missing)
(28 real changes made, 28 to missing)
(36 real changes made, 36 to missing)
(40 real changes made, 40 to missing)
(40 real changes made, 40 to missing)
(38 real changes made, 38 to missing)
(38 real changes made, 38 to missing)
(38 real changes made, 38 to missing)
(38 real changes made, 38 to missing)
(38 real changes made, 38 to missing)
(37 real changes made, 37 to missing)
(38 real changes made, 38 to missing)
(35 real changes made, 35 to missing)
(32 real changes made, 32 to missing)
(35 real changes made, 35 to missing)
(34 real changes made, 34 to missing)
(33 real changes made, 33 to missing)
(29 real changes made, 29 to missing)
(32 real changes made, 32 to missing)

. 
. * YEAR-SPECIFIC HOURLY WAGES POST-TRIMMING *
. forvalues y = 1992(1)2019 {
  2. 
. di as text "POST-TRIMMED HOURLY WAGE IN YEAR: `y'"
  3. summarize hwage if year == `y', detail
  4. 
. }
POST-TRIMMED HOURLY WAGE IN YEAR: 1992

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         1.05              1
 5%         1.75              1
10%         2.45              1       Obs               1,674
25%         4.25              1       Sum of Wgt.       1,674

50%            6                      Mean           7.056269
                        Largest       Std. Dev.      4.488215
75%         8.75       25.71429
90%       12.975       25.94595       Variance       20.14407
95%        16.25          25.95       Skewness       1.587679
99%           25          26.25       Kurtosis       6.119585
POST-TRIMMED HOURLY WAGE IN YEAR: 1993

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%          1.2              1
 5%     1.923077              1
10%          2.5              1       Obs               1,609
25%          4.5              1       Sum of Wgt.       1,609

50%            6                      Mean           7.356336
                        Largest       Std. Dev.      4.709609
75%            9       26.66667
90%           14         26.875       Variance       22.18041
95%     17.33333       27.02703       Skewness       1.563594
99%           25         28.125       Kurtosis       5.745972
POST-TRIMMED HOURLY WAGE IN YEAR: 1994

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%     1.090909              1
 5%            2              1
10%        3.125              1       Obs               1,436
25%     4.947429              1       Sum of Wgt.       1,436

50%          6.5                      Mean           7.943383
                        Largest       Std. Dev.      5.290659
75%      9.42973             30
90%           15             30       Variance       27.99107
95%        19.86             31       Skewness        1.76249
99%       26.923       32.14286       Kurtosis       6.370729
POST-TRIMMED HOURLY WAGE IN YEAR: 1995

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         1.25              1
 5%     2.380952              1
10%        3.692              1       Obs               1,451
25%            5              1       Sum of Wgt.       1,451

50%         6.75                      Mean           8.273988
                        Largest       Std. Dev.      5.329275
75%           10       32.28571
90%           15           33.2       Variance       28.40117
95%           20       33.33325       Skewness       1.813792
99%           28             34       Kurtosis       6.900674
POST-TRIMMED HOURLY WAGE IN YEAR: 1996

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%     1.411742       1.111111
 5%         2.45       1.111111
10%         3.75       1.111111       Obs               1,200
25%            5       1.142857       Sum of Wgt.       1,200

50%         6.75                      Mean           8.079394
                        Largest       Std. Dev.      4.841492
75%        9.995       29.36486
90%       14.423        29.6968       Variance       23.44005
95%     18.39633         30.625       Skewness       1.698014
99%     26.15788       30.95225       Kurtosis       6.504552
POST-TRIMMED HOURLY WAGE IN YEAR: 1997

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%     1.176471              1
 5%          2.5              1
10%            4              1       Obs               1,271
25%          5.5              1       Sum of Wgt.       1,271

50%         7.25                      Mean           8.966506
                        Largest       Std. Dev.      5.848467
75%      10.3845         34.375
90%        16.63        35.4165       Variance       34.20457
95%     21.15375          35.76       Skewness       1.887089
99%        31.25             36       Kurtosis         7.1748
POST-TRIMMED HOURLY WAGE IN YEAR: 1998

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%          1.5           1.25
 5%            3           1.25
10%          4.9           1.25       Obs               1,281
25%          5.9           1.25       Sum of Wgt.       1,281

50%          7.5                      Mean           9.153169
                        Largest       Std. Dev.      5.300837
75%      10.9615             30
90%           17             30       Variance       28.09887
95%       20.192             30       Skewness       1.498379
99%     27.14286         30.625       Kurtosis       5.301862
POST-TRIMMED HOURLY WAGE IN YEAR: 1999

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         1.75       1.111111
 5%       3.4615           1.25
10%            5           1.25       Obs               1,288
25%            6           1.25       Sum of Wgt.       1,288

50%            8                      Mean           10.06758
                        Largest       Std. Dev.      6.199306
75%           12       39.56029
90%           19             40       Variance       38.43139
95%      23.4614             40       Skewness       1.708318
99%       32.051             40       Kurtosis       6.385702
POST-TRIMMED HOURLY WAGE IN YEAR: 2000

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            2       1.285714
 5%     3.729596            1.5
10%            5          1.575       Obs               1,331
25%          6.5          1.575       Sum of Wgt.       1,331

50%          8.5                      Mean           10.49177
                        Largest       Std. Dev.      6.279534
75%         12.1          33.65
90%           20       33.65375       Variance       39.43254
95%           25         33.721       Skewness       1.560349
99%        31.25             35       Kurtosis       5.207211
POST-TRIMMED HOURLY WAGE IN YEAR: 2001

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            2          1.546
 5%         3.75           1.55
10%         5.15         1.5625       Obs               1,468
25%     6.827778          1.575       Sum of Wgt.       1,468

50%            9                      Mean           10.95615
                        Largest       Std. Dev.       6.70189
75%     12.91538          42.93
90%           20          42.93       Variance       44.91533
95%           25          43.25       Skewness       1.799502
99%      34.2105         43.269       Kurtosis         6.8499
POST-TRIMMED HOURLY WAGE IN YEAR: 2002

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         2.55       1.923056
 5%     4.615143              2
10%            6              2       Obs               1,421
25%            7              2       Sum of Wgt.       1,421

50%         9.17                      Mean           11.08167
                        Largest       Std. Dev.      6.072833
75%     13.05714           37.5
90%     19.23067        38.4615       Variance       36.87931
95%      24.3055       38.75956       Skewness       1.640823
99%     32.04444        40.1315       Kurtosis       6.036094
POST-TRIMMED HOURLY WAGE IN YEAR: 2003

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%          2.5              2
 5%            5              2
10%         5.75              2       Obs               1,937
25%            7              2       Sum of Wgt.       1,937

50%            9                      Mean           10.67259
                        Largest       Std. Dev.      5.870286
75%        12.03             37
90%        18.75           37.5       Variance       34.46026
95%       24.038           37.5       Skewness       1.816845
99%     32.89474          37.68       Kurtosis       6.705094
POST-TRIMMED HOURLY WAGE IN YEAR: 2004

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            3         2.3075
 5%            5         2.3076
10%            6         2.3076       Obs               1,961
25%            7            2.5       Sum of Wgt.       1,961

50%         9.05                      Mean           10.93761
                        Largest       Std. Dev.      5.765436
75%     12.98075        36.0575
90%           19           37.7       Variance       33.24025
95%           24             38       Skewness       1.702492
99%     32.05125          38.45       Kurtosis       6.234167
POST-TRIMMED HOURLY WAGE IN YEAR: 2005

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         2.75          2.019
 5%         5.15          2.125
10%            6           2.13       Obs               1,969
25%          7.5           2.13       Sum of Wgt.       1,969

50%         9.75                      Mean           11.34894
                        Largest       Std. Dev.      5.958277
75%      13.4615          38.45
90%     19.54545          38.45       Variance       35.50106
95%     24.03825          38.45       Skewness       1.628707
99%     32.14286       38.57143       Kurtosis       6.121636
POST-TRIMMED HOURLY WAGE IN YEAR: 2006

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%     2.966857           2.13
 5%         5.25           2.15
10%         6.25           2.28       Obs               1,961
25%         7.75         2.3076       Sum of Wgt.       1,961

50%           10                      Mean            11.7951
                        Largest       Std. Dev.      6.382496
75%        13.97         40.375
90%           20       40.86525       Variance       40.73626
95%           25       40.86525       Skewness       1.785406
99%     35.71429           40.9       Kurtosis       6.745137
POST-TRIMMED HOURLY WAGE IN YEAR: 2007

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         3.47           2.37
 5%         5.75           2.37
10%          6.5           2.38       Obs               1,948
25%            8            2.5       Sum of Wgt.       1,948

50%           10                      Mean           12.13371
                        Largest       Std. Dev.      6.528526
75%     14.34278       41.74286
90%     21.04762             42       Variance       42.62165
95%        25.95       42.02857       Skewness       1.746275
99%           36           42.6       Kurtosis       6.409825
POST-TRIMMED HOURLY WAGE IN YEAR: 2008

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%     3.333333            2.5
 5%            6           2.65
10%            7       2.666667       Obs               1,910
25%            8       2.818182       Sum of Wgt.       1,910

50%      10.3615                      Mean           12.61875
                        Largest       Std. Dev.      6.864674
75%     14.90375          43.25
90%      21.6345             44       Variance       47.12375
95%         27.5           44.2       Skewness       1.829105
99%     38.46143         44.225       Kurtosis       6.733939
POST-TRIMMED HOURLY WAGE IN YEAR: 2009

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         3.75       2.083333
 5%          6.5           2.15
10%         7.25           2.35       Obs               1,920
25%     8.245857            2.5       Sum of Wgt.       1,920

50%         10.5                      Mean            13.0927
                        Largest       Std. Dev.      7.474694
75%           15        48.4615
90%     23.09838             50       Variance       55.87105
95%     29.78462             50       Skewness        1.98069
99%       41.825       50.48075       Kurtosis       7.493312
POST-TRIMMED HOURLY WAGE IN YEAR: 2010

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         4.32              3
 5%            7              3
10%         7.25              3       Obs               1,885
25%          8.5          3.125       Sum of Wgt.       1,885

50%           11                      Mean               13.3
                        Largest       Std. Dev.      7.201098
75%         15.5        44.7115
90%     23.21425       45.52632       Variance       51.85581
95%       28.846         46.625       Skewness       1.832856
99%      40.3845           47.3       Kurtosis       6.649569
POST-TRIMMED HOURLY WAGE IN YEAR: 2011

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            4           2.65
 5%            7           2.65
10%          7.4           2.75       Obs               1,897
25%          8.5           2.75       Sum of Wgt.       1,897

50%        10.75                      Mean           13.41564
                        Largest       Std. Dev.      7.826769
75%        15.17          55.55
90%           23         55.625       Variance       61.25831
95%       28.409          55.75       Skewness       2.376726
99%        48.06          57.65       Kurtosis       10.32413
POST-TRIMMED HOURLY WAGE IN YEAR: 2012

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         3.75           2.65
 5%            7           2.65
10%     7.475875           2.65       Obs               1,870
25%          8.5          2.769       Sum of Wgt.       1,870

50%     10.70214                      Mean             13.306
                        Largest       Std. Dev.      7.508571
75%        15.38       50.13043
90%       23.075       51.16279       Variance       56.37864
95%        28.75          51.25       Skewness       2.094106
99%       43.269       51.42857       Kurtosis       8.356048
POST-TRIMMED HOURLY WAGE IN YEAR: 2013

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%     4.333333            3.2
 5%         7.25            3.2
10%      7.69225          3.205       Obs               1,784
25%            9       3.262626       Sum of Wgt.       1,784

50%           11                      Mean           13.80152
                        Largest       Std. Dev.      7.838135
75%      15.5875             50
90%       24.025          52.05       Variance       61.43636
95%        31.25       52.72222       Skewness       2.096313
99%           45       53.64368       Kurtosis       7.998371
POST-TRIMMED HOURLY WAGE IN YEAR: 2014

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%          4.9            3.6
 5%         7.25           3.75
10%            8           3.75       Obs               1,755
25%            9           3.75       Sum of Wgt.       1,755

50%       11.525                      Mean           14.20932
                        Largest       Std. Dev.      7.783446
75%     16.48321             50
90%           25             50       Variance       60.58204
95%         30.9             50       Skewness       1.907546
99%       43.269             50       Kurtosis       7.029035
POST-TRIMMED HOURLY WAGE IN YEAR: 2015

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            5              3
 5%         7.25           3.25
10%            8       3.296571       Obs               1,797
25%            9           3.75       Sum of Wgt.       1,797

50%         11.5                      Mean           14.00493
                        Largest       Std. Dev.      7.709785
75%           16         53.125
90%        23.63       55.47327       Variance       59.44079
95%           30        57.6922       Skewness       2.192971
99%        46.15        57.6922       Kurtosis       8.964029
POST-TRIMMED HOURLY WAGE IN YEAR: 2016

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%         5.29            3.5
 5%         7.55           3.75
10%         8.15              4       Obs               1,764
25%        9.865              4       Sum of Wgt.       1,764

50%       12.019                      Mean           14.78322
                        Largest       Std. Dev.      8.024786
75%     17.02273             55
90%           25          56.25       Variance       64.39719
95%       31.875         57.675       Skewness       2.096115
99%           48        57.6922       Kurtosis       8.359153
POST-TRIMMED HOURLY WAGE IN YEAR: 2017

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%        4.925              3
 5%          7.5              3
10%        8.333       3.066667       Obs               1,742
25%           10         3.4615       Sum of Wgt.       1,742

50%       12.375                      Mean           15.36158
                        Largest       Std. Dev.      9.057661
75%        17.08           61.5
90%     26.82675       63.10094       Variance       82.04123
95%           35             64       Skewness       2.246468
99%       51.282       64.10244       Kurtosis       8.976066
POST-TRIMMED HOURLY WAGE IN YEAR: 2018

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            5              4
 5%          7.6              4
10%          8.5       4.166667       Obs               1,650
25%           10           4.25       Sum of Wgt.       1,650

50%           13                      Mean           15.44606
                        Largest       Std. Dev.      8.101379
75%           18             56
90%     25.98075         57.675       Variance       65.63234
95%           32         57.675       Skewness       1.989162
99%       48.075         57.675       Kurtosis       8.046471
POST-TRIMMED HOURLY WAGE IN YEAR: 2019

                            hwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%            5            3.8
 5%          7.5       3.898108
10%          8.5        4.32675       Obs               1,575
25%           10       4.444444       Sum of Wgt.       1,575

50%           13                      Mean           15.52955
                        Largest       Std. Dev.      8.619793
75%           18          61.25
90%           25           62.1       Variance       74.30083
95%     32.05111           62.5       Skewness       2.385785
99%           54             65       Kurtosis       10.49709

. 
. log close
      name:  <unnamed>
       log:  D:\users\llochner\Dropbox\JOINT PROJECTS\JPE_Child_Devp_2020\FINAL_Replication_CLMP_JPE/code/data_cleaning/prices/logs\wa
> getrim_cps.log
  log type:  text
 closed on:   4 Jul 2025, 13:32:08
--------------------------------------------------------------------------------------------------------------------------------------
